yilv_new/AA/Report/sql/[UFSystem]单据对照表.sql

-- 功能权限
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Base WHERE cAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001' )
BEGIN
UPDATE UA_Auth_Base SET cAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001',cSub_Id=N'SA',iGrade=N'2',cSupAuth_Id=N'SARPT',bEndGrade=N'0',iOrder=N'77',cAuthType=NULL WHERE cAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Base(cAuth_Id,cSub_Id,iGrade,cSupAuth_Id,bEndGrade,iOrder,cAuthType)VALUES(N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001',N'SA',N'2',N'SARPT',N'0',N'77',NULL)
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'en-US',cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001',cAuth_Name=N'单据对照表' WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'en-US',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001',N'单据对照表')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-CN',cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001',cAuth_Name=N'单据对照表' WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-CN',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001',N'单据对照表')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-TW',cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001',cAuth_Name=N'单据对照表' WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-TW',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001',N'单据对照表')
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Base WHERE cAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_01' )
BEGIN
UPDATE UA_Auth_Base SET cAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_01',cSub_Id=N'SA',iGrade=N'3',cSupAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001',bEndGrade=N'1',iOrder=N'77',cAuthType=NULL WHERE cAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_01' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Base(cAuth_Id,cSub_Id,iGrade,cSupAuth_Id,bEndGrade,iOrder,cAuthType)VALUES(N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_01',N'SA',N'3',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001',N'1',N'77',NULL)
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_01' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'en-US',cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_01',cAuth_Name=N'Query:单据对照表' WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_01' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'en-US',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_01',N'Query:单据对照表')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_01' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-CN',cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_01',cAuth_Name=N'查询:单据对照表' WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_01' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-CN',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_01',N'查询:单据对照表')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_01' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-TW',cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_01',cAuth_Name=N'查詢:单据对照表' WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_01' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-TW',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_01',N'查詢:单据对照表')
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Base WHERE cAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_02' )
BEGIN
UPDATE UA_Auth_Base SET cAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_02',cSub_Id=N'SA',iGrade=N'3',cSupAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001',bEndGrade=N'1',iOrder=N'77',cAuthType=NULL WHERE cAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_02' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Base(cAuth_Id,cSub_Id,iGrade,cSupAuth_Id,bEndGrade,iOrder,cAuthType)VALUES(N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_02',N'SA',N'3',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001',N'1',N'77',NULL)
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_02' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'en-US',cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_02',cAuth_Name=N'Configurat单据对照表' WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_02' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'en-US',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_02',N'Configurat单据对照表')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_02' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-CN',cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_02',cAuth_Name=N'设置:单据对照表' WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_02' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-CN',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_02',N'设置:单据对照表')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_02' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-TW',cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_02',cAuth_Name=N'設置:单据对照表' WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_02' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-TW',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_02',N'設置:单据对照表')
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Base WHERE cAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_03' )
BEGIN
UPDATE UA_Auth_Base SET cAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_03',cSub_Id=N'SA',iGrade=N'3',cSupAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001',bEndGrade=N'1',iOrder=N'77',cAuthType=NULL WHERE cAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_03' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Base(cAuth_Id,cSub_Id,iGrade,cSupAuth_Id,bEndGrade,iOrder,cAuthType)VALUES(N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_03',N'SA',N'3',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001',N'1',N'77',NULL)
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_03' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'en-US',cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_03',cAuth_Name=N'Print:单据对照表' WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_03' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'en-US',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_03',N'Print:单据对照表')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_03' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-CN',cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_03',cAuth_Name=N'打印:单据对照表' WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_03' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-CN',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_03',N'打印:单据对照表')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_03' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-TW',cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_03',cAuth_Name=N'列印:单据对照表' WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_03' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-TW',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_03',N'列印:单据对照表')
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Base WHERE cAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_04' )
BEGIN
UPDATE UA_Auth_Base SET cAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_04',cSub_Id=N'SA',iGrade=N'3',cSupAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001',bEndGrade=N'1',iOrder=N'77',cAuthType=NULL WHERE cAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_04' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Base(cAuth_Id,cSub_Id,iGrade,cSupAuth_Id,bEndGrade,iOrder,cAuthType)VALUES(N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_04',N'SA',N'3',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001',N'1',N'77',NULL)
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_04' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'en-US',cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_04',cAuth_Name=N'Output:单据对照表' WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_04' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'en-US',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_04',N'Output:单据对照表')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_04' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-CN',cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_04',cAuth_Name=N'输出:单据对照表' WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_04' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-CN',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_04',N'输出:单据对照表')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_04' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-TW',cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_04',cAuth_Name=N'輸出:单据对照表' WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_04' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-TW',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_04',N'輸出:单据对照表')
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Base WHERE cAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_05' )
BEGIN
UPDATE UA_Auth_Base SET cAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_05',cSub_Id=N'SA',iGrade=N'3',cSupAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001',bEndGrade=N'1',iOrder=N'77',cAuthType=NULL WHERE cAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_05' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Base(cAuth_Id,cSub_Id,iGrade,cSupAuth_Id,bEndGrade,iOrder,cAuthType)VALUES(N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_05',N'SA',N'3',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001',N'1',N'77',NULL)
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_05' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'en-US',cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_05',cAuth_Name=N'Publish:单据对照表' WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_05' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'en-US',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_05',N'Publish:单据对照表')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_05' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-CN',cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_05',cAuth_Name=N'发布:单据对照表' WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_05' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-CN',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_05',N'发布:单据对照表')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_05' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-TW',cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_05',cAuth_Name=N'發佈:单据对照表' WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_05' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-TW',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_05',N'發佈:单据对照表')
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Base WHERE cAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_f45802d3-ef66-42f6-965c-266d4756396e' )
BEGIN
UPDATE UA_Auth_Base SET cAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_f45802d3-ef66-42f6-965c-266d4756396e',cSub_Id=N'SA',iGrade=N'3',cSupAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001',bEndGrade=N'1',iOrder=N'77',cAuthType=NULL WHERE cAuth_Id=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_f45802d3-ef66-42f6-965c-266d4756396e' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Base(cAuth_Id,cSub_Id,iGrade,cSupAuth_Id,bEndGrade,iOrder,cAuthType)VALUES(N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_f45802d3-ef66-42f6-965c-266d4756396e',N'SA',N'3',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001',N'1',N'77',NULL)
END
GO


IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_f45802d3-ef66-42f6-965c-266d4756396e' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'en-US',cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_f45802d3-ef66-42f6-965c-266d4756396e',cAuth_Name=N'View:单据对照表' WHERE localeid=N'en-US' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_f45802d3-ef66-42f6-965c-266d4756396e' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'en-US',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_f45802d3-ef66-42f6-965c-266d4756396e',N'View:单据对照表')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_f45802d3-ef66-42f6-965c-266d4756396e' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-CN',cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_f45802d3-ef66-42f6-965c-266d4756396e',cAuth_Name=N'视图:单据对照表' WHERE localeid=N'zh-CN' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_f45802d3-ef66-42f6-965c-266d4756396e' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-CN',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_f45802d3-ef66-42f6-965c-266d4756396e',N'视图:单据对照表')
END
GO
IF EXISTS(SELECT TOP 1 * FROM UA_Auth_Lang WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_f45802d3-ef66-42f6-965c-266d4756396e' )
BEGIN
UPDATE UA_Auth_Lang SET localeid=N'zh-TW',cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_f45802d3-ef66-42f6-965c-266d4756396e',cAuth_Name=N'視圖:单据对照表' WHERE localeid=N'zh-TW' AND cAuth_ID=N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_f45802d3-ef66-42f6-965c-266d4756396e' 
END
ELSE
BEGIN
INSERT INTO UA_Auth_Lang(localeid,cAuth_ID,cAuth_Name)VALUES(N'zh-TW',N'SA[__]f4452c0a-d7a0-47f0-a53a-42b1249b3ba9_001_f45802d3-ef66-42f6-965c-266d4756396e',N'視圖:单据对照表')
END
GO


-- 门户菜单相关
DELETE FROM UfSystem..UA_Menu WHERE cMenu_Id=N'SARPT232635' 
INSERT INTO UfSystem..UA_Menu(cMenu_Id,cMenu_Name,cMenu_Eng,cSub_Id,IGrade,cSupMenu_Id,bEndGrade,cAuth_Id,iImgIndex,Paramters,Depends,Flag)VALUES(N'SARPT232635',N'单据对照表',N'4',N'SA',N'1',N'SA',N'1',NULL,N'0',NULL,NULL,NULL)
GO

DELETE FROM UfSystem..UFMenu_Business_Lang WHERE MenuId=N'SARPT232635' AND LocaleId=N'en-US' 
INSERT INTO UfSystem..UFMenu_Business_Lang(MenuId,Caption,LocaleId)VALUES(N'SARPT232635',N'单据对照表',N'en-US')
DELETE FROM UfSystem..UFMenu_Business_Lang WHERE MenuId=N'SARPT232635' AND LocaleId=N'zh-CN' 
INSERT INTO UfSystem..UFMenu_Business_Lang(MenuId,Caption,LocaleId)VALUES(N'SARPT232635',N'单据对照表',N'zh-CN')
DELETE FROM UfSystem..UFMenu_Business_Lang WHERE MenuId=N'SARPT232635' AND LocaleId=N'zh-TW' 
INSERT INTO UfSystem..UFMenu_Business_Lang(MenuId,Caption,LocaleId)VALUES(N'SARPT232635',N'单据对照表',N'zh-TW')
GO

DELETE FROM UfSystem..ua_idt WHERE id=N'SARPT232635' 
INSERT INTO UfSystem..ua_idt(id,assembly,catalogtype,type,class,entrypoint,parameter,reserved)VALUES(N'SARPT232635',N'.\UAP\UFIDA.U8.UAP.Services.ReportManagement.dll',N'0',N'2',N'UFIDA.U8.UAP.Services.ReportManagement.OpenReportServer4PortalMenu',NULL,NULL,NULL)
GO